data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

When data changes in multiple lists and all lists are not updated, this causes

a) data redundancy

b) information overload

c) duplicate data

d) data inconsistency

e) data repetition

Question : 37

How do businesses protect their databases?

a) Security guards are hired to watch the databases at all times.

b) Databases are protected by file swapping.

c) Databases are naturally protected.

d) Databases are kept physically and electronically secure.

e) The computer room is kept locked after office hours.

Question : 38 [IBPS Clerk, 2012]

ROLLBACK in a database is ________ statement

a) TCL

b) DCL

c) DML

d) DDL

e) SDL

Question : 39 [IBPS PO, 2013]

Where will we find the referential integrity command ?

a) Tools

b) View

c) Format

d) Table

e) None of these

Question : 40

A tuple is a

a) column of a table

b) two-dimensional table

c) row of a table

d) key of a table

e) None of these